<?php session_start();?>

<?php if(isset($_SESSION['user'])){ ?> 
<html>
<head>
<title>Course Fee Collection </title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
.style1 {
	font-family: Cambria;
	color: #000080;
}
.style2 {color: #000099}
-->
</style>
</head>
<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<!-- ImageReady Slices (Untitled-1) -->
<table width="620" height="650" border="0" align="center" cellpadding="0" cellspacing="0" id="Table_01">
	<tr>
		<td><table width="620" height="204" border="0" background="images/report_01.png">
          <tr height="10%">
            <td><div align="center">
              <h1 class="style1">NAWODAYA INSTITUTE (PVT) LTD </h1>
            </div></td>
          </tr>
          <tr height="10%">
            <td bgcolor="#FFFFFF"> <div align="center" class="style2">No: 66/12, <br>
Yatiyanthota road,<br>
Awissawella. </div></td>
          </tr>
          <tr>
            <td><div align="center" class="style2">Tel : 036-2230454/Fax : 94-3-2687014<br>
            Email : avinavodaya@gmail.com</div></td>
          </tr>
		  
		  <tr>
		    <td>&nbsp;</td>
		  </tr>
          <tr>
            <td height="3" background="images/report_04.png" style="background-repeat:no-repeat">&nbsp;</td>
          </tr>
        </table></td>
	</tr>
	<tr>
		<td><table width="620" height="700" border="0" background="images/report_02.png">
          <tr>
            <td height="100" colspan="3"><h3 align="center">Monthly Course Fee Collection for Individual Class </h3>
            <br/>
			 <?php 
			include'../logic/Classes/reportHandler.php';   
			include'../logic/Classes/db.php'; 
			
            $subgr=$_GET['subgr'];
			$year=$_GET['year'];
			$month=$_GET['month'];
			
			$x=new DbConnect();
            $con=$x->getConnection();
			
			$rep=new ReportHandler();
			$rep->setCon($con);
			
			$result=$rep->getIndividualReport($subgr,$year,$month);
			$time_now=mktime(date('H')+5,date('i')+30,date('s'),date('m'),date('d'),date('Y'));
			$num=mysql_num_rows($result);
			
			if($month==1){
            $mon="January";
            } elseif($month==2){
            $mon="February";
            } elseif($month==3){
            $mon="March";
           } elseif($month==4){
           $mon="April";
          } elseif($month==5){
          $mon="May";
          } elseif($month==6){
          $mon="June";
         }elseif($month==7){
         $mon="July";
         }elseif($month==8){
         $mon="August";
        }elseif($month==9){
        $mon="September";
        }elseif($month==10){
        $mon="October";
        }elseif($month==11){
        $mon="November";
        } else{
        $mon="December";
         }
			?>
            
			 <?php while($row=mysql_fetch_array($result) ) { ?>
			<?php // check the number of rows are not zero  
			 if(isset($row['income'])){ ?>
              <table width="100%" border="0">
			     <tr>
                  <td width="29%"><strong>Year </strong></td>
                  <td width="3%"><strong>:</strong></td>
                  <td width="68%"><?php echo $year; ?></td>
                </tr>
                <tr>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                </tr>
                <tr>
                  <td><strong>Month</strong></td>
                  <td><strong>:</strong></td>
                  <td><?php echo $mon; ?></td>
                </tr>
                <tr>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                </tr>
                <tr>
                  <td><strong>Subject</strong></td>
                  <td><strong>:</strong></td>
                  <td><?php echo $row['subject']; ?></td>
                </tr>
                <tr>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                </tr>
                <tr>
                  <td><strong>Grade</strong></td>
                  <td><strong>:</strong></td>
                  <td><?php echo $row['grade']; ?></td>
                </tr>
                <tr>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                </tr>
                <tr>
                  <td><strong>Paid Fee of Each Student </strong></td>
                  <td><strong>:</strong></td>
                  <td><?php echo "Rs.".$row['p_fee'].".00"; ?></td>
                </tr>
                <tr>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                </tr>
                <tr>
                  <td><strong>No of Students </strong></td>
                  <td><strong>:</strong></td>
                  <td><?php echo $row['numb']; ?></td>
                </tr>
                <tr>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                </tr>
                <tr>
                  <td><strong>Income</strong></td>
                  <td><strong>:</strong></td>
                  <td><?php echo "Rs.".$row['income'].".00";  ?></td>
                </tr>
                <tr>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                </tr>
				
              </table>
			 
			   <?php } else{ ?> <div align="center"> <strong> There is no record to display </strong></div><?php } ?>
			    <?php } ?>
			  </td>
          </tr>
          <tr height="70%">
            <td height="20" colspan="3"></td>
          </tr>
          <tr height="70%">
            <td height="20" colspan="3"></td>
          </tr>
          <tr height="70%">
            <td height="20" colspan="3"></td>
          </tr>
          <tr height="70%">
            <td height="20" colspan="3"></td>
          </tr>
          <tr height="70%">
            <td height="20" colspan="3"></td>
          </tr>
          <tr height="70%">
            <td height="20" colspan="3"></td>
          </tr>
          <tr height="70%">
            <td height="20" colspan="3"></td>
          </tr>
          <tr height="70%">
            <td height="20" colspan="3"></td>
          </tr>
          <tr height="70%">
            <td height="20" colspan="3"></td>
          </tr>
          <tr height="70%">
            <td height="20" colspan="3"></td>
          </tr>
          <tr height="70%">
            <td height="20" colspan="3"></td>
          </tr>
          
          <tr height="70%">
            <td height="20" background="images/Untitled-1.jpg">&nbsp;&nbsp;<?php echo $_SESSION['user']; ?></td>
            <td></td>
            <td background="images/Untitled-1.jpg">&nbsp;&nbsp;&nbsp;<?php echo date('Y-m-d',$time_now);  ?></td>
          </tr>
          <tr height="70%">
            <td width="104" height="20"><strong>&nbsp;&nbsp;Issued By <strong> </td>
            <td width="385"></td>
            <td width="117" >&nbsp;&nbsp;<strong>Issued</strong> <strong>Date</strong></td>
          </tr>
          <tr height="70%"><td colspan="3">&nbsp;</td></tr>
          
         
        </table></td>
	</tr>
	<tr>
		<td><table width="620" height="42" border="0" background="images/report_03.png">
          <tr>
            <td><div align="left" class="style2">
              <div align="center">Generated By NAWODAYA MIS</div>
            </div></td>
          </tr>
        </table></td>
	</tr>
</table>
<!-- End ImageReady Slices -->
</body>
</html>
<?php  } else { header("location:../../index.php");   }?>